/********************************************************************* * * Copyright (C) 2004 Andrew Khan * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA ***************************************************************************/ package jxl.write.biff; import jxl.common.Logger; import jxl.ErrorFormulaCell; import jxl.biff.FormulaData; import jxl.biff.IntegerHelper; import jxl.biff.formula.FormulaErrorCode; import jxl.biff.formula.FormulaException; import jxl.biff.formula.FormulaParser; /** * Class for read number formula records */ class ReadErrorFormulaRecord extends ReadFormulaRecord implements ErrorFormulaCell { // The logger private static Logger logger = Logger.getLogger(ReadErrorFormulaRecord.class); /** * Constructor * * @param f */ public ReadErrorFormulaRecord(FormulaData f) { super(f); } /** * Gets the error code for this cell. * * @return the cell contents */ public int getErrorCode() { return ( (ErrorFormulaCell) getReadFormula()).getErrorCode(); } /** * Error formula specific exception handling. Can't really create * a formula (as it will look for a cell of that name, so just * create a STRING record containing the contents * * @return the bodged data */ protected byte[] handleFormulaException() { byte[] expressiondata = null; byte[] celldata = super.getCellData(); int errorCode = getErrorCode(); String formulaString = null; if (errorCode == FormulaErrorCode.DIV0.getCode()) { formulaString = "1/0"; } else if (errorCode == FormulaErrorCode.VALUE.getCode()) { formulaString = "\"\"/0"; } else if (errorCode == FormulaErrorCode.REF.getCode()) { formulaString = "\"#REF!\""; } else { formulaString = "\"ERROR\""; } // Generate an appropriate dummy formula WritableWorkbookImpl w = getSheet().getWorkbook(); FormulaParser parser = new FormulaParser(formulaString, w, w, w.getSettings()); // Get the bytes for the dummy formula try { parser.parse(); } catch(FormulaException e2) { logger.warn(e2.getMessage()); } byte[] formulaBytes = parser.getBytes(); expressiondata = new byte[formulaBytes.length + 16]; IntegerHelper.getTwoBytes(formulaBytes.length, expressiondata, 14); System.arraycopy(formulaBytes, 0, expressiondata, 16, formulaBytes.length); // Set the recalculate on load bit expressiondata[8] |= 0x02; byte[] data = new byte[celldata.length + expressiondata.length]; System.arraycopy(celldata, 0, data, 0, celldata.length); System.arraycopy(expressiondata, 0, data, celldata.length, expressiondata.length); // Set the type bits to indicate an error data[6] = 2; data[12] = -1; data[13] = -1; // Set the error code data[8] = (byte) errorCode; return data; } }